You receive an error in SQL executing 45.05.05 SQLDataProvider
KBA-01079-S47WPZ
Problem

When installing Postcard Manager you receive this error:

StartJob Start Sql execution: 45.05.05.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Incorrect syntax near 'iwebs_PM_Cards'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) create procedure dbo.dnn_iwebs_PM_AddCard @ModuleId int, @CardUrl nvarchar(500), @CreatedBy int, @CreatedDate datetime, @Comments nvarchar(2000), @ViewOrder int, @SendCount int as insert into dbo.dnn_ iwebs_PM_Cards ( ModuleId, CardUrl, CreatedBy, CreatedDate, Comments, ViewOrder, SendCount ) values ( @ModuleId, @CardUrl, @CreatedBy, @CreatedDate, @Comments, @ViewOrder, @SendCount ) SELECT SCOPE_IDENTITY()
EndJob End Sql execution: 45.05.05.SqlDataProvider file

Solution
Install a version of the module later than 45.05.09
Additional Comments
We identified some code in version before this that failed to run on some database servers with particular language settings. We have fixed this in later versions.



http://www.interactivewebs.com